﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;

namespace Museum.DBAccess
{
    public class Constants
    {
        #region Stored Procedures

        public const string SP_GETMUSEUMS = "sp_GetMuseums";
        public const string SP_GETGAMES = "SP_GetGames";
        public const string SP_DOWNLOADGAME = "SP_DownloadGame";
        public const string SP_CHECKGAMEUPDATE = "SP_CheckGameUpdate";
        public const string SP_GETTOPGAMESCORE = "SP_GetTopGameScore";
        public const string SP_INSERTGAMESCORE = "SP_InsertGameScore";
        public const string SP_INSERTREVIEW = "SP_InsertReview";
        public const string SP_SEARCHARTICLES = "sp_SearchArticles";
        public const string SP_GETREVIEWS = "sp_GetMuseumReviews";
        public const string SP_GETARTICLESBYTYPE = "sp_GetArticlesByType";
        public const string SP_INSERTARTICLE = "sp_InsertArticle";
        public const string SP_GETCATEGORIES = "SP_GetMuseumCategories";
        public const string SP_GETTOUR = "SP_GetTour";
        public const string SP_GETSEARCHART = "SP_GETSEARCHART";
        public const string SP_GETTREASUREDETAILS = "SP_GetTreasureDetails";
        public const string SP_VALIDATEVOUCHER = "sp_ValidateVoucher";
        public const string SP_GETARTS = "SP_GETARTS";
        public const string SP_GETARTDETAIL = "SP_GETARTDETAIL";
        public const string SP_GETCITIES = "SP_GETCITIES";
        public const string sp_GetCity = "sp_GetCity";
        public const string SP_GETALLSCHOOLS = "sp_GetAllSchools";

        #region "Portal SP's"

        public const string SP_GETCOUNTRIES = "SP_GETCOUNTRIES";
        public const string SP_GETMUSEUMBYID = "SP_GETMUSEUMBYID";
        public const string SP_INSERTORUPDATEMUSEUMDETAILS = "sp_InsertOrUpdateMuseumDetails";
        public const string SP_GETALLGAMES = "sp_GetAllGames";
        public const string SP_GETALLTOURS = "sp_GetAllTours";
        public const string SP_GETGAMEBYID = "SP_GETGAMEBYID";
        public const string SP_VALIDATEUSER = "sp_ValidateUser";
        public const string SP_INSERTORUPDATEGAMEDETAILS = "sp_InsertOrUpdateGameDetails";
        public const string SP_INSERTORUPDATECLUEDETAILS = "sp_InsertOrUpdateClueDetails";
        public const string SP_INSERTORUPDATETOURDETAILS = "sp_InsertOrUpdateTourDetails";
        public const string SP_INSERTORUPDATECITYDETAILS = "sp_InsertOrUpdateCityDetails";
        public const string SP_INSERTORUPDATESCHOOLDETAILS = "sp_InsertOrUpdateSchoolDetails";
        public const string sp_SearchSettings = "sp_SearchSettings";
        public const string SP_GETALLCITIES = "sp_GetAllCities";
        public const string SP_GETCLUEBYGAMEID = "sp_GetClueByGameId";
        public const string SP_UPDATEMUSEUMDETAILS = "sp_UpdateMuseumDetails";
        public const string SP_GETTOURBYID = "sp_GetTourById";
        public const string SP_DELETEMUSEUMDATA = "sp_DeleteMuseumData";
        public const string SP_GETALLMUSEUMS = "sp_GetAllMuseums";
        public const string SP_GETSEARCHSETTINGS = "sp_GetSearchSettings";
        public const string SP_DELETTOURDATA = "sp_DeleteTourData";
        public const string SP_DELETEGAMEDATA = "sp_DeleteGameData";
        public const string SP_INSERTVOUCHER = "SP_InsertVoucher";
        public const string SP_INSERTORUPDATECATEGORY = "SP_InsertOrUpdateCategory";
        public const string SP_GETCATEGORYDETAILS = "SP_GetCategoryDetails";
        public const string SP_DELETECATEGORYDATA = "sp_DeleteCategoryData";
        public const string SP_DELETEVOUCHERDATA = "sp_DeleteVoucherData";
        public const string SP_GETVOUCHERDETAILS = "SP_GetVoucherDetails";
        public const string SP_GETALLCOUNTRIES = "sp_GetAllCountries";
        public const string SP_DELETECITYDATA = "sp_DeleteCityData";
        public const string SP_INSERTORUPDATEUSER = "SP_InsertOrUpdateUser";
        public const string SP_GETUSERDETAILS = "SP_GetUserDetails";
        public const string SP_DELETESCHOOLDATA = "sp_DeleteSchoolData";
        public const string SP_GETSCHOOLDETAILS = "SP_GetSchoolDetails";
        public const string SP_GETARTASSETSBYARTID = "sp_GetArtAssetsByArtId";
        public const string SP_GETSCHOOLBYMUSEUMID = "sp_GetSchoolByMuseumId";
        public const string SP_GETTOURSBYMUSEUMID = "sp_GetToursByMuseumId";
        public const string SP_GETGAMESBYMUSEUMID = "SP_GetGamesByMuseumId";
        public const string SP_GETGAMESBYSCHOOLID = "SP_GetGamesBySchoolId";
        public const string SP_GETMUSEUMBYSCHOOLID = "sp_GetMuseumBySchoolId";
        public const string SP_DELETEREVIEWDATA = "sp_DeleteReviewData";
        public const string SP_GETGAMESBYOPTION = "SP_GetGamesByOption";
        public const string SP_GETANALYTICSDATA = "sp_GetAnalyticsData";
        public const string SP_DELETEARTASSETDATA = "sp_DeleteArtAssetData";

        #endregion

        public const string VW_Categories = "VW_Categories";
        #endregion

        public const string CityMinDate = "2010-01-01";
    }
}
